SELECT *, CASE WHEN `name` LIKE "hyde park%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hyde park" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hyde park" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hyde park" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("hyde park") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
$795,000Ruth Dr Lot 9Hyde Park NY 12538View Listing
$789,00094 Huyler DrHyde Park NY 12538View Listing
$785,000Ruth Dr Lot 8Hyde Park NY 12538View Listing
$775,000Ruth Dr Lot 5Hyde Park NY 12538View Listing
$775,000Ruth Dr Lot 14Hyde Park NY 12538View Listing
$775,000Ruth Dr Lot 21Hyde Park NY 12538View Listing
$775,000Adams Ln Lot 28Hyde Park NY 12538View Listing
$769,000Ruth Dr Lot 10Hyde Park NY 12538View Listing
$769,000Adams Ln Lot 23Hyde Park NY 12538View Listing
$759,000Ruth Dr Lot 7Hyde Park NY 12538View Listing
$749,90014 Kari BlvdHyde Park NY 12601View Listing
$749,000Ruth Dr Lot 4Hyde Park NY 12538View Listing
$749,000Ruth Dr Lot 15Hyde Park NY 12538View Listing
$749,000Ruth Dr Lot 18Hyde Park NY 12538View Listing
$749,000Adams Ln Lot 22Hyde Park NY 12538View Listing
$749,000Adams Ln Lot 26Hyde Park NY 12538View Listing
$749,000Ruth Dr Lot 30Hyde Park NY 12538View Listing
$745,000Adams Ln Lot 27Hyde Park NY 12538View Listing
$739,000Ruth Dr Lot 12Hyde Park NY 12538View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 7:49:11 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah